College Scorecard

Introduction

This is our R Notebook, showing the steps we took to complete the Final Project for CS 329E. This notebook includes step-by-step instructions on how to reproduce our project. To obtain our data, we used data.world.

R Configuration

Below we display our sessionInfo().

sessionInfo(package=NULL)

Data Description

The data was found on “Dr. John Rasp’s Statistics Website” (http://www2.stetson.edu/~jrasp/data.htm). It is a subset of the data from College Scorecard, a Department of Education website that gives data on various variables regarding tuition, costs and school performance.

An explanatory key for the recorded variables can be found here: https://data.world/jlee/s-17-dv-final-project/file/CollegeScorecard_ColumnNames.pdf

Cleaning Data

Here’s our ETL file to clean our data set.

source("../01 Data/R_ETL.CollegeScorecard.R")

Cleaned up Data Download

Cleaned data can be downloaded from Data.world as a .csv file. Because the dataset is so large, we filtered to only show some rows.

Hosting User: jlee
Database: S17 DV Final Project
Dataset Name: CollegeScorecard.csv

Download Link: https://query.data.world/s/dv5dl8q1jx2qb3d3bd2976b9d

source("../01 Data/Accessdataworld.R")

Side by Side Shiny and Tableau Visualizations

Descriptions: Refer to visualization captions for individual descriptions.

Boxplot: Average Cost of Attendance for Type of School

These boxplots (Tableau left, Shiny right) demonstrate

Histogram: SAT Averages for Universities

These histograms (Tableau left, Shiny right) dfddf

Scatterplot: Instructional Expenditures vs. Net tuition

These scatterplots (Tableau left, Shiny right) explore the correlation between Instructional expenditures per full-time equivalent student and Net tuition revenue per full-time equivalent student.

Crosstab 1: Instructional Expenditures / Cost of Attendance

These crosstabs (Tableau left, Shiny right) xxxx

Crosstab 2: Tuition Revenue / Total Cost

These crosstabs (Tableau left, Shiny right) xxxx

Map 1: Region Cost of Attendance (Instructional Expenditures / Cost of Attendance)

These maps (Tableau left, Shiny right) demonstrate the distribution of instructional expenditure / cost of attendance ratio across the United States, where darker colors indicate higher ratios.

Map 2: Tuition Revenue to Total Cost

These maps (Tableau left, Shiny right) demonstrate the distribution of tuition revenue / total cost ratio across the United States, where darker colors indicate higher ratios.

Barchart: Instructional Expense per Type of Instutition


These barcharts (Tableau left, Shiny right) xxxx

Shiny Visualization and Published Application

Description: Full size static .pngs of the Shiny application, as well as a link to the live published version.

Published Link:
https://ehjkim.shinyapps.io/shinyfinal/

Boxplot: Average Cost of Attendance for Type of School

Histogram: SAT Averages for Universities

Scatterplot: Instructional Expenditures vs. Net tuition

Crosstab 1: Instructional Expenditures/Cost of Attendance

Crosstab 2: Tuition Revenue / Total Cost

Map 1: Region Cost of Attendance (Instructional Expenditures / Cost of Attendance)

Map 2: Tuition Revenue to Total Cost

Barchart: Instructional Expense per Type of Instutition

Tableau / Tableau Action Generated Visualizations

Descriptions: Full size static .pngs of the tableau visualizations. Refer to visualization captions for individual descriptions.

Boxplot: Average Cost of Attendance for Type of School

Histogram: SAT Averages for Universities

Scatterplot: Instructional Expenditures vs. Net tuition

Crosstab 1: Instructional Expenditures/Cost of Attendance

Crosstab 2: Tuition Revenue / Total Cost

Map 1: Region Cost of Attendance (Instructional Expenditures / Cost of Attendance)

Map 2: Tuition Revenue to Total Cost

Barchart: Instructional Expense per Type of Instutition